create table qrtz_fired_triggers
(
    sched_name        nvarchar(120) not null,
    entry_id          nvarchar(95)  not null,
    trigger_name      nvarchar(200) not null,
    trigger_group     nvarchar(200) not null,
    instance_name     nvarchar(200) not null,
    fired_time        bigint        not null,
    sched_time        bigint        not null,
    priority          int           not null,
    state             nvarchar(16)  not null,
    job_name          nvarchar(200),
    job_group         nvarchar(200),
    is_nonconcurrent  nvarchar,
    requests_recovery nvarchar,
    primary key (sched_name, entry_id)
)
go

exec sp_addextendedproperty 'MS_Description', '已触发的触发器表', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_fired_triggers'
go

exec sp_addextendedproperty 'MS_Description', '调度名称', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_fired_triggers', 'COLUMN',
     'sched_name'
go

exec sp_addextendedproperty 'MS_Description', '调度器实例id', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_fired_triggers', 'COLUMN',
     'entry_id'
go

exec sp_addextendedproperty 'MS_Description', 'qrtz_triggers表trigger_name的外键', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_fired_triggers', 'COLUMN', 'trigger_name'
go

exec sp_addextendedproperty 'MS_Description', 'qrtz_triggers表trigger_group的外键', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_fired_triggers', 'COLUMN', 'trigger_group'
go

exec sp_addextendedproperty 'MS_Description', '调度器实例名', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_fired_triggers', 'COLUMN',
     'instance_name'
go

exec sp_addextendedproperty 'MS_Description', '触发的时间', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_fired_triggers', 'COLUMN',
     'fired_time'
go

exec sp_addextendedproperty 'MS_Description', '定时器制定的时间', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_fired_triggers', 'COLUMN',
     'sched_time'
go

exec sp_addextendedproperty 'MS_Description', '优先级', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_fired_triggers', 'COLUMN',
     'priority'
go

exec sp_addextendedproperty 'MS_Description', '状态', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_fired_triggers', 'COLUMN', 'state'
go

exec sp_addextendedproperty 'MS_Description', '任务名称', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_fired_triggers', 'COLUMN',
     'job_name'
go

exec sp_addextendedproperty 'MS_Description', '任务组名', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_fired_triggers', 'COLUMN',
     'job_group'
go

exec sp_addextendedproperty 'MS_Description', '是否并发', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_fired_triggers', 'COLUMN',
     'is_nonconcurrent'
go

exec sp_addextendedproperty 'MS_Description', '是否接受恢复执行', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_fired_triggers', 'COLUMN',
     'requests_recovery'
go

